<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
 "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<title>school</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="date" content="Thu, 13 Nov 2018 15:52:37 +0800">
	<meta name="generator" content="MySQL-Front 5.3  (Build 2.42)">
	<style type="text/css"><!--
		body {font-family: Arial,Helvetica,sans-serif; font-size: 12px;}
		h1 {font-size: 18px; text-decoration: bold;}
		h2 {font-size: 16px; text-decoration: bold;}
		h3 {font-size: 14px; text-decoration: bold;}
		th,
		td {font-size: 12px; border-color: #000000; border-style: solid; border-width: 1px; padding: 1px; font-weight: normal;}
		code {font-size: 19px;}
		.TableObject {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableData {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableHeader {border-color: #000000; text-decoration: bold; background-color: #e0e0e0;}
		.StructureHeader {padding-left: 5px; text-align: left; border-color: #000000; text-decoration: bold;}
		.Structure {text-align: left; border-color: #aaaaaa;}
		.odd {}
		.even {}
		.DataHeader {padding-left: 5px; text-align: left; border-color: #000000; background-color: #e0e0e0;}
		.Null {color: #999999;}
		.PrimaryKey {font-weight: bold;}
		.RightAlign {text-align: right;}
	--></style>
</head>
<body>
<h1 class="DatabaseTitle">数据库: school</h1>
<h2>表格: stuinfo</h2>
<table border="0" cellspacing="0" summary="stuinfo" class="TableData">
	<tr class="TableHeader"><th class="DataHeader PrimaryKey">stuid</th><th class="DataHeader">stuname</th><th class="DataHeader">stusex</th><th class="DataHeader">stunum</th><th class="DataHeader">stuage</th></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">1</th><td class="">小雪</td><td class="">女</td><td class="">2018101001</td><td class="RightAlign">18</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">2</th><td class="">peipei</td><td class="">女</td><td class="">2018101002</td><td class="RightAlign">20</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">3</th><td class="">大猪蹄子</td><td class="">男</td><td class="">2018101003</td><td class="RightAlign">21</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">4</th><td class="">红姐</td><td class="">女</td><td class="">2018101004</td><td class="RightAlign">19</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">5</th><td class="">肖哥</td><td class="">女</td><td class="">2018101005</td><td class="RightAlign">20</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">8</th><td class="">小红</td><td class="">女</td><td class="">2018101007</td><td class="RightAlign">18</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">9</th><td class="">小明</td><td class="">男</td><td class="">2018101008</td><td class="RightAlign">22</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">10</th><td class="">小猪佩琪</td><td class="">男</td><td class="">2018101009</td><td class="RightAlign">3</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">11</th><td class="">李婷</td><td class="">女</td><td class="">2018101010</td><td class="RightAlign">23</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">14</th><td class="">张三</td><td class="">男</td><td class="">2018101011</td><td class="RightAlign">13</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">15</th><td class="">李四</td><td class="">女</td><td class="">2018101012</td><td class="RightAlign">20</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">16</th><td class="">李白</td><td class="">男</td><td class="">2018101013</td><td class="RightAlign">20</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">17</th><td class="">李晓燕</td><td class="Null">&nbsp;</td><td class="">2018101014</td><td class="RightAlign">20</td></tr>
</table><br style="page-break-after: always">
<h2>表格: sturesult</h2>
<table border="0" cellspacing="0" summary="sturesult" class="TableData">
	<tr class="TableHeader"><th class="DataHeader PrimaryKey">resultid</th><th class="DataHeader">stuid</th><th class="DataHeader">sbjectsid</th><th class="DataHeader">score</th></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">1</th><td class="RightAlign">1</td><td class="RightAlign">1</td><td class="RightAlign">80</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">2</th><td class="RightAlign">1</td><td class="RightAlign">2</td><td class="RightAlign">70</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">3</th><td class="RightAlign">1</td><td class="RightAlign">3</td><td class="RightAlign">88</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">4</th><td class="RightAlign">2</td><td class="RightAlign">1</td><td class="RightAlign">90</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">5</th><td class="RightAlign">2</td><td class="RightAlign">2</td><td class="RightAlign">88</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">6</th><td class="RightAlign">2</td><td class="RightAlign">3</td><td class="RightAlign">90</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">7</th><td class="RightAlign">2</td><td class="RightAlign">4</td><td class="RightAlign">88</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">8</th><td class="RightAlign">2</td><td class="RightAlign">5</td><td class="RightAlign">92</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">9</th><td class="RightAlign">3</td><td class="RightAlign">1</td><td class="RightAlign">88</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">10</th><td class="RightAlign">3</td><td class="RightAlign">2</td><td class="RightAlign">88</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">11</th><td class="RightAlign">3</td><td class="RightAlign">3</td><td class="RightAlign">90</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">12</th><td class="RightAlign">3</td><td class="RightAlign">4</td><td class="RightAlign">88</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">13</th><td class="RightAlign">3</td><td class="RightAlign">5</td><td class="RightAlign">92</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">14</th><td class="RightAlign">5</td><td class="RightAlign">1</td><td class="RightAlign">88</td></tr>
</table><br style="page-break-after: always">
<h2>表格: subjects</h2>
<table border="0" cellspacing="0" summary="subjects" class="TableData">
	<tr class="TableHeader"><th class="DataHeader PrimaryKey">sbjectsid</th><th class="DataHeader">subjectsname</th><th class="DataHeader">period</th></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">1</th><td class="">大学语文</td><td class="RightAlign">20</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">2</th><td class="">高等数学</td><td class="RightAlign">18</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">3</th><td class="">IT英语</td><td class="RightAlign">20</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">4</th><td class="">静态网页</td><td class="RightAlign">12</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">5</th><td class="">web前端框架</td><td class="RightAlign">15</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">6</th><td class="">职业素养</td><td class="RightAlign">10</td></tr>
	<tr class="Data odd"><th class="PrimaryKey RightAlign">7</th><td class="">php</td><td class="RightAlign">14</td></tr>
	<tr class="Data even"><th class="PrimaryKey RightAlign">8</th><td class="">C#从入门到精通</td><td class="RightAlign">22</td></tr>
</table><br style="page-break-after: always">
</body>
</html>
